StockLedgerAccountHistory

Entity Definition

Logical Name : StockLedgerAccountHistory
Physical Name : LE_HST_STKACT

A reporting period based record of the beginning balance and cumulative activity for a particular MerchandiseHierarchyGroup during the current ReportingPeriod. Records both raw Item numbers as well as a Valuation amount - The valuation figures for any particular StockLedgerAccount may be either RetailValuation or CostPriceValuation as required by the needs of the retail enterprise.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
ReportingPeriodID (FK)(PK) The unique system assigned identifier for a particular ReportingPeriod. ID_PRD_RP Identity integer ReportingPeriod(CA_PRD_RP)
MerchandiseHierarchyGroupID (FK)(PK) Unique system assigned identifier for a group or class of merchandise. ID_MRHRC_GP Identity integer StockLedgerAccount(LE_STKACT)
RevenueCostCenterID (FK)(PK) A unique retailer assigned identifier for an accounting budget, that owns merchandise and is used to track the financial performance of the retail enterprise. ID_CTR_RVN_CST Identity integer StockLedgerAccount(LE_STKACT)
StockLedgerAccountValuationType A retailer assigned code denoting which valuation method is used to value the Items owned by the MerchandisingRevenueCenter being tracked. Possible values include - Retail Valuation; Last Known Cost Valuation; Average Weighted Cost Valuation, Replacement Cost Valuation. TY_STKG_VLN Code2 char(2)
BeginningUnitCount The number of all Items owned by the MerchandisingCenter at the beginning of the historical ReportingPeriod. QU_UN_BGN QuantityTransactionCount decimal(7,0)
CumulativeGrossSalesUnitCount The cumulative unit sales for a specific ITEM since the beginning of the historical ReportingPeriod, excluding any returns. QU_SLS_GS_CM QuantityTransactionCount decimal(7,0)
CumulativeReturnUnitCount The cumulative number of units returned of a specific ITEM since the beginning of the historical ReportingPeriod. QU_RTN_CM QuantityTransactionCount decimal(7,0)
CumulativeReceivedUnitCount The cumulative number of units received for a particular ITEM since the beginning of the historical ReportingPeriod. QU_RCV QuantityTransactionCount decimal(7,0)
CumulativeTransferInUnitCount The cumulative number of units of a specific ITEM transferred into the RETIL STORE since the beginning of the historical ReportingPeriod. QU_TSF_IN_CM QuantityTransactionCount decimal(7,0)
CumulativeTransferOutUnitCount The cumulative number of units of a specific ITEM transferred out to other RETIL STOREs or other FACILITYs within the retail enterprise since the beginning of the historical ReportingPeriod. QU_TSF_OT_CM QuantityTransactionCount decimal(7,0)
CumulativeReturnToVendorUnitCount The cumulative number of units of a specific ITEM returned to the vendor since the beginning of the historical ReportingPeriod. QU_RTN_TO_VN QuantityTransactionCount decimal(7,0)
CumulativeAdjustmentUnitCount The cumulative adjustment made to the on hand amount of an ITEM since the start of the historical ReportingPeriod. QU_UN_ADJT_CM QuantityTransactionCount decimal(7,0)
CurrentUnitCount The number of all Items owned by the MerchandisingCenter at the end of the historical ReportingPeriod. QU_UN_CRT QuantityTransactionCount decimal(7,0)

Relationships

Parent Entity Verb Phrase Child Entity
ReportingPeriod delineates StockLedgerAccountHistory
StockLedgerAccount is tracked by StockLedgerAccountHistory

Logical Views containing StockLedgerAccountHistory

Logical View
Logical 02000 - Item Inventory and Stock Ledger View
Logical 03000 - Reporting - Macro View
Logical 03000 - Reporting - Macro View
Logical 03300 - Reporting - Stock Ledger View